SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524821 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524821 [ RunTime:0.007185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129263,4167,175766,1019302,62811,92325,565467,656375,1007099,885780,219916,879983,1021677,323484,492985,408029,35665,285358,215719,865032,796976,823580,495425,224220,168973,829462,424395,426501,280406,279706,901070,1012039,693278,733361,621742,830963,279416,194049,667151,978484,36942,321625,224607,998793,454056,892001,306176,690167,810167,1009224,214220,258391,1044116,77900,432869,644734,384484,254111,292152,712751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]