SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343611 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343611 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845537,821682,1044833,202494,367834,937081,287686,765696,430386,232028,492778,36019,171646,592580,992675,23036,504810,1024040,634629,805662,664881,900553,115692,231342,950855,409151,983089,191269,38524,687448,361081,764114,226447,242228,120627,306050,1025447,202469,961003,574800,8676,162169,459654,543003,454346,563493,734684,753577,243287,650454,619136,311320,504495,761767,1030561,771639,228313,96663,857418,1042328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]