SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429016 LIMIT 1 [ RunTime:0.001146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429016 [ RunTime:0.003868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525941,226252,61535,760601,929818,367653,27733,754569,471744,942336,227761,277825,939632,450209,560087,1003031,938460,734933,700121,881972,166173,208613,872165,451159,734180,380861,15124,99223,551048,303007,624217,401308,1034372,593997,393992,318711,1014229,1025505,492537,51250,207543,956327,843794,450067,199091,332754,517832,672591,681540,542574,192131,446879,879408,716129,1033655,724737,311225,757025,405699,947877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]