SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180813 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180813 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679121,698970,571216,952219,953668,133087,702931,812791,875041,768001,163280,73038,942286,266431,791257,127477,892691,982649,333626,208497,1001306,751000,281745,330663,1001877,101614,336411,454033,694966,429937,496794,8393,72266,28252,232412,896858,166007,16051,790073,625638,41269,145185,222135,557717,628526,716407,477676,45322,1041518,723865,435639,841990,15313,139555,1041460,566203,472813,545152,1278,214978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]