SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040433 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040433 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297882,317083,580717,69708,984096,211696,180141,302267,811324,293119,148740,237564,701514,1005086,961219,1024548,726050,324502,687981,96454,349451,951058,594124,16165,712554,208750,685407,432074,873389,118063,147416,793802,529887,352431,423565,511345,754223,250272,667532,737734,373600,328006,665729,477199,901240,245936,809477,130857,137903,264815,210580,222596,1039349,935198,30745,388003,841625,708058,752364,911960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000801s ]