SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024716 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024716 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728711,973876,423291,734472,373009,295945,599636,628646,998657,169388,45225,891898,168901,364244,729660,847332,828962,226097,203625,253772,948850,772985,623321,275294,1003874,816021,871683,787849,643450,344016,460310,146141,142783,523077,835433,60786,291558,148939,766114,1029613,44595,500069,387462,954002,716909,993543,115766,417718,451075,965574,74033,760763,367283,155805,409661,660578,672464,133596,1013960,575079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]