SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421260 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421260 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678544,850917,127474,286013,142701,517932,107538,123742,629405,682998,244540,351589,631655,825486,46732,566404,804065,9827,763013,620706,804248,9219,166436,155040,369002,271351,298094,817514,1005641,498772,264206,1009489,985672,737199,1033554,655814,768370,244235,883003,154457,456692,219944,409998,823989,302595,702397,730269,672985,290895,183133,883952,269783,918713,207263,425739,741638,4277,255008,1004366,39148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]