SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579920 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579920 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853395,573019,174057,579354,126696,508766,545218,322665,831960,1047091,534115,703447,693865,1013585,1024361,153238,407653,64171,1010265,306460,359979,473611,1040129,505083,393889,678920,499447,192908,869032,747616,859864,32273,354140,52392,216025,265733,563094,185714,166737,320623,741928,957756,460375,85110,136183,772407,1034593,759960,158897,413927,961140,655071,117023,56451,324545,1007300,377034,535569,6366,910252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]