SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40546 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40546 [ RunTime:0.001279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410620,945954,263786,77354,206160,291495,490343,622358,214394,1022983,354027,379016,235391,844632,858466,384328,104183,72401,69283,567628,557148,825754,370720,18879,460236,661298,710227,907566,25808,728903,617625,638549,348899,1047770,301875,530282,630206,881164,633760,328580,620436,976691,373021,212730,880234,247417,342664,146853,442059,294043,256665,59237,199394,550095,723057,611543,932176,1003808,768908,688980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]