SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411990 LIMIT 1 [ RunTime:0.004404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411990 [ RunTime:0.004818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172070,259621,969697,624719,899552,641587,605483,946763,1003319,504675,456765,742813,928273,284816,560595,669594,444697,735392,820231,712522,934119,873669,203691,49491,283044,135384,262708,701367,673357,123123,317828,867013,129813,384485,635951,87616,278149,253477,427762,770958,953128,400937,611410,922725,246613,447854,516906,786336,891207,660199,95997,920843,1003749,180308,851116,807315,332487,1008377,982550,67667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001265s ]