SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671823 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671823 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513601,476870,1021602,542169,842193,614296,683677,913585,796337,620683,283757,872113,360643,787637,38274,273721,475396,23547,470990,902063,595563,875586,893216,363649,479280,401331,204448,818028,998206,898520,227947,647728,890619,455772,801557,584369,14038,767610,814704,129703,990362,68535,804838,545133,296660,124497,196544,25447,542294,510514,990608,954962,871183,1027310,678264,35056,152835,1001197,1047513,326520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]