SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54229 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54229 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004367,798383,544526,105160,806163,947431,520460,791229,731837,118376,859047,151603,274146,393268,832012,300463,604419,866560,982866,919407,387588,971736,984280,353192,58006,944540,798601,298548,1007124,1039928,255761,388364,549292,740461,369943,332976,548455,996832,615751,787483,712830,771502,19405,621825,572325,584934,758069,46957,708284,973741,830600,224489,771800,310317,943850,314072,626807,405536,217350,485229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54229 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54229 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]