SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514562 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514562 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59401,422500,543539,398213,805502,700495,77782,477048,919110,333825,422930,696890,627861,286455,837045,513246,867171,84734,439100,703600,940164,1027729,253254,257452,107234,463975,172472,981730,438754,565647,465639,944739,593159,224569,908223,297315,801917,299957,617149,349051,654444,446135,460999,733017,177347,307978,104007,646635,861249,352950,976873,200190,798533,890882,382075,521571,49744,167078,878453,256554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]