SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539441 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539441 [ RunTime:0.002236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324149,578210,710789,484979,437221,874903,384178,741226,210602,1001083,165220,515671,628536,763171,762211,375639,709291,642764,968678,297591,298431,15048,841529,351008,941961,310834,268589,270609,828608,821429,224231,585169,215975,247609,800135,946962,959926,427244,4883,429784,252403,31421,331412,335399,601457,584406,464882,874796,433538,213155,774527,20267,539536,257612,83961,879160,248842,837200,218566,171359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002357s ]