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` = 861651 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861651 [ RunTime:0.003891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420366,530954,159723,139417,361056,894103,811959,674607,368989,260612,414908,2372,127328,254215,527314,142138,78682,534149,118441,613342,292347,799192,292993,1031000,1033236,242334,909579,517687,563927,95718,1020253,807263,677658,418547,565578,61955,67191,49347,290512,511662,133092,969395,225047,146351,85454,683355,328792,220702,802132,334596,288150,451541,510038,546582,207709,821630,990005,1040955,75536,741824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]