SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517941 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517941 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676813,644450,561095,704429,243028,75437,416451,983303,718118,961229,724809,343763,806888,921947,331316,328544,1026507,231020,710479,955716,755828,588874,506488,394776,477688,191112,632730,54180,325286,814882,1043422,878201,961977,881539,144563,107570,130569,45698,157667,561661,766992,303504,280412,676727,1023917,404981,237863,414578,904533,90048,110807,944828,906652,75510,727875,137138,344315,621546,527287,668881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000976s ]