SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 259541 LIMIT 1 [ RunTime:0.001099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 259541 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117934,406010,934922,37529,867567,431266,820075,940039,538844,460380,50606,474642,248088,887091,171484,831382,204868,312945,102888,396888,556221,181016,397086,375299,216913,236609,237516,21816,22658,41403,307638,854031,984661,1005588,1047733,942773,308745,902954,972889,110980,429611,937429,380313,559598,1005129,370819,304711,560973,245435,46923,794496,5188,730671,49512,17349,272876,350339,257893,649881,545383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 259541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 259541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]