SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454330 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454330 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850919,573987,751019,12805,304977,107094,851984,74334,605161,960800,197947,981147,1042505,930385,713150,317132,391325,853989,763018,509561,750306,142247,733818,852776,339329,952945,770646,363590,497720,640398,617565,283161,752538,454362,794006,323702,180389,698469,330387,731784,646369,962204,61132,974608,375426,696823,392246,974480,80751,600514,874648,102096,1033595,127531,343392,844534,217144,861840,790825,133621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]