SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001513 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001513 [ RunTime:0.004716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789558,85936,674443,827888,334178,347511,855146,533722,614695,184014,376322,270523,166098,1034579,346503,185415,597568,52180,286655,170690,703402,406703,994265,3174,470447,861021,424901,445654,914690,372391,827658,292835,535137,265784,101150,196894,801271,678287,424782,948094,949514,760332,936000,34063,268235,396487,5616,31296,1033704,794836,229743,610922,559440,117660,931998,757781,836307,560850,33574,436855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002100s ]