SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554475 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554475 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988653,401274,919747,543418,896970,580490,505885,702116,767662,297665,139969,782381,63707,1022038,487022,783101,363533,559101,1025131,24206,128439,159015,354903,147994,568185,968530,753408,950911,27536,654831,623826,182470,673671,499333,912739,911597,774006,112808,486353,758709,991176,523899,5517,969413,491493,970337,360026,614258,449557,879984,597426,836682,1000265,845494,651690,453482,497198,711239,430704,854252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]