SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557501 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557501 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653953,426710,5944,221717,741862,522080,286233,971365,894397,504989,427750,434880,533520,543987,824035,211762,141109,26291,1028033,1031009,760842,343862,878170,958898,181440,702408,86428,72815,267184,810988,887302,526876,177914,985641,194332,144129,243054,644894,821917,854303,432869,159523,552063,985292,911556,823287,762884,266450,666050,237256,779792,421887,991648,954479,709337,930188,1020820,156179,623165,230665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]