SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554581 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554581 [ RunTime:0.002027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88437,501699,668676,984315,740068,821809,61472,707260,909503,436648,608108,425746,44592,187465,418572,520652,305261,423396,172742,70180,430009,47887,124626,686151,742210,869753,684112,610905,890109,34372,914730,808261,255709,996622,128321,757091,5920,978633,948006,598750,428160,426686,360660,6264,931353,821431,720301,575363,838596,711903,73777,66535,166175,586241,461581,17888,1018365,377875,761500,272837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]