SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 232004 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 232004 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510520,981958,134416,555154,694696,1010765,776427,358516,71139,712259,527135,15066,338994,620310,1042285,536201,689353,376623,539782,81888,157836,683180,796959,818981,323905,112826,35601,356394,203460,1005768,53362,792745,460283,343209,568831,588678,34757,433760,117489,983322,160745,373410,341327,607862,533384,6593,908233,822903,328177,530239,793681,759996,48013,999556,823764,782185,483383,602912,1033706,627854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 232004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 232004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]