SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644831 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644831 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113289,244571,126298,954868,304033,1045875,407077,325516,699498,210113,505339,622500,301429,183489,129406,25925,1020045,248099,369967,397538,535054,985790,431982,312538,275285,101986,970370,165899,895018,170651,448068,490442,792431,726062,794883,725789,395636,96574,648140,332558,677509,742272,597826,132321,739205,630878,160800,137406,302366,895528,891784,510496,16091,313683,887808,343814,610338,43995,812120,918546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]