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` = 262544 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262544 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492661,783162,109860,892439,55228,1012416,27433,352823,70554,744327,471018,7340,584895,332075,672713,370521,598486,1029709,788823,995385,78505,373098,458833,962375,978528,866522,950288,201142,632672,556969,601499,549998,939463,730587,403748,718352,627958,557341,544038,671891,368049,56620,36226,628666,335285,141369,583203,980638,438874,268233,596273,799924,986631,104478,248335,618506,394370,314625,993084,471983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]