SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529511 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529511 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516337,25809,402130,556608,38519,592461,30562,820135,413581,163754,75289,755126,103413,756476,153657,409458,1031535,141402,533565,988527,1008979,299174,463010,780620,223134,19093,118123,145170,321246,642302,1037848,40864,471737,289261,980952,894096,718437,821721,126788,245503,697627,801296,356951,484186,910935,615280,425706,766029,69282,890531,297546,852337,496585,517441,487339,387615,881162,764275,116987,619226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]