SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356208 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356208 [ RunTime:0.002175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357273,368007,483833,139519,842374,48535,451758,942282,423475,322269,274509,155836,201498,50555,99990,153180,106252,34238,190478,102141,915619,921125,308211,689192,161161,644938,370562,193951,229779,739918,985639,943900,425540,1007925,919047,622200,849536,500516,94253,468129,470563,388894,312464,459871,196662,227707,97201,838750,142188,57370,680343,516815,302465,504773,739261,101074,302984,672710,17392,390393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]