SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 891091 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 891091 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794590,983857,1048533,254104,98208,954424,830117,325792,111070,693254,834741,480290,49029,565370,746074,659956,464970,965566,185871,822635,731298,58829,1047761,905778,212161,888824,436445,999423,64498,525841,895260,902521,720453,829245,394656,65367,96279,1018299,589243,542417,857824,469819,362393,1031134,814384,668095,428061,379820,40006,395247,1021595,473855,995102,1004045,500132,842392,902139,979729,279440,307669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 891091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 891091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]