SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427765 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427765 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16097,1021909,663167,527645,557969,1048343,892671,26217,337444,403741,684033,250426,1018103,904566,239095,434194,746856,610359,87582,912326,1033609,656892,228747,17872,90667,190524,429346,773084,561465,699473,770111,574366,47282,962543,371705,801072,878938,44571,238962,438880,871764,369205,724147,695028,858515,525526,728276,971005,720570,20881,146174,983227,946926,128915,389069,870347,160481,536924,25169,525915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]