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` = 1019828 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019828 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886498,470264,911873,489116,264120,722869,513608,58035,235147,454155,70588,1029560,394264,1009409,543930,611735,1038894,627312,708354,864331,368410,751875,91408,722463,890468,950431,128185,25283,519015,681661,690530,788292,988695,832274,552167,835830,411567,811837,837790,509240,582874,887363,5207,601843,180097,423876,635059,740613,27057,915875,786787,913670,54000,61568,81593,176694,192622,475448,354624,316760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]