SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972518 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972518 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345926,424743,500619,1004166,336129,505708,325877,24491,6833,393928,285720,898727,777523,750334,588324,332487,285903,891874,44885,428735,822003,447592,951717,765375,473752,390109,431272,690194,577365,660454,269272,298875,20514,361582,177678,402724,943393,174504,310679,1035882,507054,839780,357668,162934,226647,918560,886820,812767,560946,810080,129007,799465,318589,823597,739162,201999,324462,695159,536238,328749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]