SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562812 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562812 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175717,1025082,274482,721857,721046,249017,379501,96935,492742,401381,825905,163154,286432,370228,88316,374957,390475,297055,245880,654927,16346,217452,593633,197093,992527,709233,279170,166100,5529,684168,261672,870157,342459,437149,229198,910535,179280,671711,406566,155364,146232,687495,669162,390819,303908,1022301,384917,229602,531787,166900,766416,251520,450085,974184,650563,588820,820697,145624,436127,868765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]