SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19501 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19501 [ RunTime:0.004387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009572,833518,534059,305370,816556,194028,841308,491353,272331,778399,670725,418263,150038,63737,996895,1001944,253088,793518,834204,364286,72772,504989,687604,744093,750857,1026349,542357,592862,203535,529598,627264,1005709,716978,685059,43175,617393,717252,111721,310303,730943,826468,748149,1030518,245838,630426,274569,689377,205195,886100,930299,516514,740746,812038,63601,456729,769011,823633,179604,311723,697969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]