SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496614 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496614 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391495,724408,830987,303781,280812,248456,1008459,208476,1013978,358521,682981,676090,583430,356871,836633,639657,948419,646623,927136,619863,691196,114820,586985,461039,498381,386607,225111,344589,565461,12310,1027421,751667,225162,40789,444251,718416,769768,760773,506925,109171,380888,438129,68483,655763,508702,110273,442478,520995,300440,837172,159364,741832,209986,635691,824487,717167,520566,811164,754874,26267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]