SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003544 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003544 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89669,325909,213849,66792,319073,736870,517849,122971,714015,222804,435849,279765,281705,428188,441290,355255,812231,962510,684449,183875,284779,107052,124126,807770,1025468,179077,685355,711878,808595,198910,881645,978078,498288,174955,521355,551088,219202,114562,849532,596747,299755,853915,255841,193893,589905,1026954,274213,90986,917381,719088,116114,698586,130662,965231,258934,465002,968799,173005,450508,421749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]