SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556531 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556531 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681769,456391,406314,438270,31072,491799,672420,407771,72113,835392,38638,494766,897906,310220,502051,930409,716585,785699,194799,769573,294260,638461,772884,952588,550938,563967,204305,619068,610984,353518,574721,377659,541988,266329,508452,532312,37884,845284,643389,192521,440476,80380,824688,463145,793229,303962,791543,414905,702930,345281,255943,152962,554927,403602,18538,156207,912886,327881,255392,186052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]