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` = 47598 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47598 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668748,1009652,766981,786230,988573,195064,1038440,84462,252276,429436,27205,142210,917535,578226,733056,698764,334960,719068,1045352,785207,596814,222060,927805,601917,174705,752946,590549,761017,917241,334241,871496,709400,388552,992256,123243,988129,960626,993389,30040,894231,1046982,776185,432380,271200,974138,958730,423648,12446,33154,433056,217022,147238,485247,360801,356147,240533,152746,159040,873277,491675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001634s ]