SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524743 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524743 [ RunTime:0.002941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95920,766960,589899,56778,599803,463981,739614,1008619,747892,923480,523456,1038924,938516,143176,417360,405794,820299,148908,66840,754371,415382,232979,463430,347715,213723,450995,525860,882032,496997,556679,520840,353196,400576,143602,599667,817627,834327,475054,855994,436701,582684,662921,307497,1013585,877037,790242,491233,701986,512491,778592,685998,523362,573824,927524,553009,700129,113492,732454,495781,252211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]