SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434533 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434533 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524804,545571,548209,920489,352855,109865,240528,385070,812742,745114,76612,668626,318429,488596,98509,917321,926601,979330,773871,880146,995906,714044,692181,648611,5109,986249,624266,462521,689063,40021,69034,98379,654190,1037574,800763,171775,786837,793748,162980,41849,458795,840853,655723,109456,941445,816758,23572,467470,714263,788503,297814,834423,14678,348312,717696,535360,358836,801712,171750,739874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]