SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504968 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504968 [ RunTime:0.002709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512096,756613,25460,816249,510098,173072,158298,966681,167017,457034,224860,64583,694945,727714,841225,282744,991066,413055,996967,496720,186805,137578,821824,686648,493141,15188,731922,821475,432952,291874,712181,96256,994202,893521,240919,145104,667764,703591,136666,844283,551132,684017,280119,584749,1035192,432451,698656,805960,835008,454139,245192,881578,873072,462465,68458,621303,762082,32431,850367,103317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]