SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550075 LIMIT 1 [ RunTime:0.001432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550075 [ RunTime:0.005849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42096,219599,462568,454365,428703,182327,541979,778088,366895,31736,953608,904710,955363,154503,456852,136097,108313,242867,323604,260512,909310,578165,690780,980356,537658,564694,448374,20479,34237,686518,791726,614084,295702,220957,80678,965682,803159,670459,661373,244844,401193,91228,155289,338908,908567,168934,748373,755895,1046657,645394,59554,39189,279584,206881,769598,277312,17809,567378,552489,1034807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002532s ]