SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045903 LIMIT 1 [ RunTime:0.001986s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045903 [ RunTime:0.002807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427173,442212,505947,483156,458322,916398,986127,778407,984367,848927,864616,969948,288419,226581,254366,487658,801100,89978,285739,556571,541657,696175,887000,421271,1027237,730798,845419,929971,751350,609628,509796,387067,842630,3721,594456,877564,365200,799522,866231,1030684,118228,601018,872880,189339,176753,154961,155356,580012,59760,21298,206722,42624,225759,526248,732573,937422,146425,421437,77193,522824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]