SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410304 LIMIT 1 [ RunTime:0.003512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410304 [ RunTime:0.005056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670945,400091,438902,85732,239137,607038,133495,174667,977250,997780,961191,515040,393450,441970,1001363,68675,487069,65898,842555,580832,537128,775569,874771,356875,360171,750136,326442,628827,656512,910026,359604,998454,460443,342492,522628,523087,623037,427727,145958,109855,263008,64307,229891,477584,500815,591671,245102,433073,812015,677820,9631,927962,41190,231689,92011,94477,1016181,811012,32111,158127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002802s ]