SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014385 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014385 [ RunTime:0.005184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37429,53669,754580,383256,217282,88701,786827,667952,264216,256215,646269,708553,173521,752698,390221,71290,1001632,487673,625308,569698,175954,410805,1042161,10911,821532,446879,1005086,941781,33318,960644,79960,261993,695405,523510,515192,469981,146521,852820,51077,848975,564265,444923,521760,577434,378793,1047074,13360,404575,154526,804591,20717,412170,83693,636276,713181,632071,804898,224968,238024,539299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]