SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916102 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916102 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156951,716694,977614,314277,755658,1017672,982294,47243,269868,685818,58229,476522,879249,552700,913282,454078,830411,631416,55505,1039404,884856,655924,10656,392772,472506,704786,34264,24436,1029310,646487,161595,885409,583414,840395,354294,762495,780368,512643,683437,551548,173460,614818,744707,509268,1005981,260552,348945,963226,586416,663138,93987,451314,887413,13106,241690,1040066,1047350,354106,149594,120383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]