SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450883 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450883 [ RunTime:0.004063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027440,760336,239689,274866,25616,374705,167053,300563,716569,1041962,892012,596372,753683,985133,260723,172562,571311,744603,946916,272774,172564,839445,227769,280440,872424,16393,438291,712009,243618,406766,673369,605307,491216,484260,153606,772256,976556,576901,783959,114744,887954,732091,547411,232929,57096,914486,103794,299663,458256,609530,489358,289943,261174,16986,692869,651909,115030,422055,143670,877234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]