SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515970 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515970 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480402,1022768,496908,456907,183047,1028997,37206,235180,1013362,755314,182102,546206,835275,385805,449795,267178,379837,1034163,786885,758713,379453,676138,470185,719529,924711,560640,616723,939511,885360,302285,687707,216358,171265,977934,872649,125079,393561,21768,998535,436496,967506,636252,356313,13766,697388,938439,738921,748042,918461,409536,275183,69954,838305,177824,375040,677115,648198,363231,870488,252697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]