SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028823 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028823 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775890,212864,1022367,166387,192064,638057,413647,372928,324510,285948,992067,773139,846720,557589,789138,215104,303346,859152,939970,60706,704516,424432,220598,271475,231010,131175,399736,962330,1040020,43589,426054,57604,862209,466391,34972,917783,780059,516817,470567,121114,653516,485622,524273,446746,2921,412623,580796,21645,323118,946597,455419,656076,168670,992643,91765,409658,448115,140787,649014,186764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]