SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010568 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010568 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153509,64148,520036,540294,729219,502947,89275,141304,979365,539848,593909,515258,172988,161463,85210,164748,621406,1026670,887340,634183,442959,743015,751581,587007,873981,182402,887074,654888,994001,255157,242343,498386,131880,839412,276461,349619,32389,803264,615441,596094,945106,274797,63312,358048,148000,875853,701339,104139,605508,31815,544041,224136,875059,791262,864887,589286,196534,751703,247756,1024242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]