SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501680 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501680 [ RunTime:0.003304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314663,542693,597616,77845,461518,538702,609777,794352,469505,698925,209718,270124,519777,440478,633581,106402,348763,627052,514456,529315,292043,216669,265876,257285,174803,551281,101174,601840,397238,695115,688617,276079,705185,994140,256224,202960,724299,704614,211130,980811,400395,217100,330723,824354,722167,160727,512502,812375,971231,96032,924610,711889,197311,1042219,737150,150438,323872,103081,267160,219437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]