SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97668 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97668 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88412,380867,519745,106048,84219,933237,929402,357198,180825,517490,168743,440801,1047483,399559,40014,791773,391024,184536,95317,618550,703468,229666,667884,2017,696148,658746,52184,502762,44327,758796,361288,687952,137457,504246,766372,645043,863727,1007147,241858,875352,1042717,117299,366085,931371,28982,777258,67347,1030955,1031208,616907,219611,266152,562768,321688,236273,809451,361022,400516,766439,697221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]