SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102214 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102214 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931842,963495,964418,236751,830425,54004,1023428,896348,796825,574858,986512,521697,251391,553648,99080,292834,1047161,587957,265878,77428,320472,569230,786204,693716,916272,99234,540428,149640,852282,924822,313321,593874,379797,743726,27832,169136,787480,112015,122620,354902,533759,407133,483379,492648,462276,606195,584386,188303,407799,822601,767315,400318,485659,135680,132950,898293,28860,232485,246170,839046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001556s ]