SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442102 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442102 [ RunTime:0.003060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034594,492627,330722,1039447,354131,371999,394495,598615,503026,774651,162032,388614,900371,553044,682747,799330,430984,144567,669669,541580,180760,954120,159042,920645,285982,900105,298490,886913,135045,684035,722755,352383,56670,634555,712107,830037,956388,409742,879709,625960,799396,986718,316380,793410,455992,79671,495032,722638,746479,549229,9829,836955,777826,695793,63592,955943,970381,58523,1018136,992381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]