SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533148 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533148 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830117,8228,258848,308248,301308,861996,534230,5077,918199,253311,813236,83684,406777,504287,491951,203774,39449,428882,359951,530807,543205,439942,42428,667029,484258,530233,917440,482044,867075,1012929,914415,346741,331989,743870,798166,518459,95467,687258,722545,405263,857770,515982,603684,166789,20400,498180,915698,533277,820036,691027,242389,258889,977193,401832,985720,551675,557173,818365,117831,170502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]