SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042008 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042008 [ RunTime:0.004268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585921,330541,564032,514043,70403,112205,440116,675161,867872,411377,680234,575065,526974,914706,114427,879415,387293,388533,200204,959264,555223,1047554,388512,377353,155029,5809,293115,631736,550774,748121,610122,886555,720629,38776,360050,707935,845981,1040255,666852,961255,159276,528769,559134,182124,1017600,21884,748711,779105,802915,810642,848681,530083,925620,64038,335328,245402,768517,706423,120419,338419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]