SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543417 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543417 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18528,791590,3230,122326,539202,83395,973272,471700,475049,490780,714435,549880,875376,518991,511247,403481,4813,297526,876466,219793,87692,79994,880575,224913,2230,283834,572287,32817,725879,659505,249528,490630,801539,223221,441007,692220,892781,817232,184080,462792,709452,368496,271238,8372,602317,761899,238151,887594,447440,1010414,286791,421283,766307,987732,83202,796547,959565,437784,260457,806857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]