SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287096 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287096 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555033,887222,113309,274263,605013,104320,125400,525819,895583,285792,33590,807232,769291,283144,103225,161764,356135,396762,150974,597290,999201,563270,1023248,992566,206236,906304,542181,97621,212515,24060,597811,675073,561599,708776,716216,65791,360010,148224,980034,115624,112162,554380,140521,533779,813806,516701,432893,240618,582256,643243,286422,720757,692625,1030614,559989,25521,797969,696377,319249,309548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]