SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49804 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49804 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457839,147013,712181,314594,689631,784419,853854,987745,780112,149685,713315,920575,87836,878252,55174,65318,294317,907586,1028460,1009194,786081,174604,611894,88856,777166,945161,707481,349749,459692,935966,708317,121170,306054,283734,211709,16617,213536,310596,143539,1024111,667602,46430,1013149,521326,903186,663904,440507,838736,100955,368856,275060,107005,165654,728822,933012,556287,281915,427684,935456,844866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]