SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017201 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017201 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840500,101651,529983,1029954,309768,733844,174529,410032,597684,14073,593891,353421,493268,543133,734890,880168,1043799,506532,348834,533490,903796,938344,456167,473728,386863,23483,440300,600493,86845,868900,230242,77156,633530,766250,964553,442989,111755,53636,227794,43956,38918,592651,276565,313328,917729,732605,971569,7993,287591,64812,703244,399385,923342,817793,148760,990361,480923,197210,286808,7499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]