SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020433 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020433 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133583,350398,165816,171314,839999,828402,87242,252390,1013387,526928,661232,386775,154790,289726,381126,472310,972304,764884,102257,150341,51594,832891,68044,141547,685146,745928,641087,594873,742245,185194,573331,409924,456253,850244,701798,1012125,454416,113451,367515,109567,701029,1045564,141002,561903,968180,997578,1045701,762635,425588,166130,45208,488857,152336,532566,272147,768157,15723,389305,489718,953780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002343s ]