SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473668 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473668 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505770,370114,521315,2357,917989,1028788,535977,524072,507980,883486,871885,525209,829170,480779,584797,233265,229765,800846,599766,866079,1009474,15960,446982,407810,35642,717809,709023,918206,268780,423669,97043,610286,202798,923675,733431,73811,690210,890344,83961,157689,556555,651653,350287,183440,225974,590875,91898,1014395,640896,491557,465002,609865,732768,177290,347455,564108,6911,556227,596664,996241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]