SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44548 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44548 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807126,387608,624543,957214,491884,427665,707585,878554,621542,875159,839102,31822,534873,17132,521859,182593,467530,572384,311050,362764,280234,195748,980914,690610,766877,965819,832030,999233,145864,27523,928366,804824,812222,636636,5685,604285,552331,824186,727498,422738,359490,903730,471579,34597,217305,1041526,223588,276461,24351,619506,546916,71632,548426,453732,870300,902723,192636,433717,56913,728556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]