SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432579 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432579 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376612,28941,946405,176215,285344,995198,497027,678284,847603,333132,735866,986306,337888,819523,781401,98708,473584,632954,212380,318598,627280,393172,897654,290054,39180,700889,779080,1023231,87805,791558,536406,501511,779220,705659,980105,634517,314641,847876,211870,90324,77676,318647,335287,321905,974884,261050,951980,849462,698210,207647,359939,426980,161179,626635,710436,510278,20690,534652,370799,121064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]