SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012170 LIMIT 1 [ RunTime:0.000819s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012170 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121763,872795,480519,382210,171634,429537,75823,95746,358502,915174,941305,946476,358911,44413,212501,413820,531107,125533,788444,274925,673856,805196,887993,830392,179366,638666,692210,835016,1043772,960711,754664,93950,524856,801106,801043,463515,679794,105957,81982,158321,106936,983862,396938,707011,775241,695777,958667,695725,424984,427468,338389,412950,367168,346463,395980,576063,392457,96773,1005251,150161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001141s ]