SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541665 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541665 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440576,809183,343800,682741,492005,1007751,852522,546256,88793,634586,174610,357241,877931,784033,798004,91158,101714,746066,92102,1018410,217092,680225,811352,478997,378719,319766,907510,936744,498518,46266,121646,317202,699409,597905,899429,961604,490931,1001383,738620,143735,944973,334925,993553,681043,648228,385270,673709,954010,404606,981546,39993,897541,469437,734151,274128,245395,430441,1042410,408572,66697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541665 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541665 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]