SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479216 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479216 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370048,123810,975457,904269,838019,718882,5860,305452,251144,257598,216164,488760,301366,879124,625148,348874,7787,725353,404758,401485,512840,304987,184036,157772,121692,466499,799584,566148,117386,1036985,740227,667230,929204,1038596,248103,214502,571574,798589,630422,81515,520460,662373,663789,894917,300511,538741,76815,952137,210783,501073,167933,698775,300054,837114,695320,928240,1020886,655151,162049,211004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002260s ]