SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375190 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375190 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459566,119238,301456,110455,805034,165736,917619,569045,387156,331412,1017619,574275,858551,216090,950422,453964,798840,679848,1013506,198032,553648,722061,667937,145065,462655,661732,270494,730056,348358,291937,987633,213231,586584,164268,440911,892411,468963,800077,439137,593444,303712,692613,118415,860318,35087,261113,775912,546781,514805,137854,298751,91853,558932,202538,141912,397313,646545,1037727,53287,692893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]