SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002522 LIMIT 1 [ RunTime:0.001343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002522 [ RunTime:0.008209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368167,430883,486399,772835,1000130,793764,454445,771912,923742,90043,447628,163157,597275,1001404,414611,212461,857162,346064,449316,51402,166127,622030,830047,526506,385815,171527,650227,671765,385949,855515,243800,529945,323950,544275,411411,307236,321704,438310,682355,399442,850037,46662,375126,434339,1045425,270707,27444,516590,331430,141888,418308,345762,912879,622734,251636,361398,260412,65466,464852,1000545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002752s ]