SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468937 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468937 [ RunTime:0.007121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929440,86634,843211,611958,469238,814316,240664,60808,58787,212587,815746,727498,250660,762340,793487,883628,104586,586542,495241,526414,569681,16136,206536,739050,822289,814031,90076,48440,201138,446551,1023044,174915,216120,478837,1019815,853272,659926,186102,733839,206872,304997,946122,370791,23999,816558,388917,633903,395547,78272,559748,942021,983159,562296,15359,99656,1044173,818651,649994,956562,362945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]