SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480889 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480889 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302016,257475,955547,594530,792151,722655,801972,781088,481963,593031,395677,163097,531416,875439,903899,99931,674245,276003,508640,552777,79934,653514,915747,998484,459625,237094,86687,720,130283,1045743,698823,82770,320138,390168,995348,593180,236692,183115,362846,668307,391226,26161,532729,888955,899245,775770,684204,984217,323580,262749,1041673,345729,11869,860468,723492,1013887,498965,129282,159378,900667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]